/*
 Navicat Premium Data Transfer

 Source Server         : Docker-150
 Source Server Type    : MySQL
 Source Server Version : 50731
 Source Host           : 192.168.144.150:3306
 Source Schema         : lagou

 Target Server Type    : MySQL
 Target Server Version : 50731
 File Encoding         : 65001

 Date: 16/12/2021 18:06:31
*/

CREATE DATABASE /*!32312 IF NOT EXISTS*/`lagou` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;

USE `lagou`;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_student
-- ----------------------------
DROP TABLE IF EXISTS `tb_student`;
CREATE TABLE `tb_student` (
  `student_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '学生ID',
  `student_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '学生名称',
  `student_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '学号',
  PRIMARY KEY (`student_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of tb_student
-- ----------------------------
BEGIN;
INSERT INTO `tb_student` VALUES (1, '张三', '20121605010137');
INSERT INTO `tb_student` VALUES (2, '李四', '20121605010138');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
